﻿use [clz]
-- =============================================
-- Author:		luohr
-- Create date: 2011-08-30
-- Description:	  添加表 ShopHoursConfig
-- =============================================
if exists (select 1
            from  sysobjects
           where  id = object_id('ShopHoursConfig')
            and   type = 'U')
DROP TABLE [dbo].[ShopHoursConfig]

/*==============================================================*/
/* Table: ShopHoursConfig                                         */
/*==============================================================*/
create table ShopHoursConfig (
   ShopHoursConfigID      int                  identity,
   ConfigName           nvarchar(50)         not null,
   Title                nvarchar(100)        null,
   Content              ntext                null,
   ShopHours            datetime             not null,
   Creater              int                  not null,
   CreatedBy            nvarchar(50)         null,
   Created              datetime             not null,
   Modified             datetime             not null,
   ModifiedBy           nvarchar(50)         null,
   ModifiedByID         int                  null,
   constraint PK_ShopHoursCONFIG primary key (ShopHoursConfigID)
)

SET IDENTITY_INSERT [dbo].[ShopHoursConfig] ON
INSERT [dbo].[ShopHoursConfig] ([ShopHoursConfigID], [ConfigName], [Title],[Content],[ShopHours],[Creater], [CreatedBy],[Created],[Modified],[ModifiedBy],[ModifiedByID]) VALUES (1, N'MStartDate', N'早上营业开始时间', N'', N'2012-01-01 06:00:00',0,N'',getdate(),getdate(), N'',0)
INSERT [dbo].[ShopHoursConfig] ([ShopHoursConfigID], [ConfigName], [Title],[Content],[ShopHours],[Creater], [CreatedBy],[Created],[Modified],[ModifiedBy],[ModifiedByID]) VALUES (2, N'MSEndDate', N'早上营业结束购物时间', N'', N'2012-01-01 09:00:00',0,N'',getdate(),getdate(), N'',0)
INSERT [dbo].[ShopHoursConfig] ([ShopHoursConfigID], [ConfigName], [Title],[Content],[ShopHours],[Creater], [CreatedBy],[Created],[Modified],[ModifiedBy],[ModifiedByID]) VALUES (3, N'MEndDate', N'早上营业结束时间', N'', N'2012-01-01 09:30:00',0,N'',getdate(),getdate(), N'',0)
INSERT [dbo].[ShopHoursConfig] ([ShopHoursConfigID], [ConfigName], [Title],[Content],[ShopHours],[Creater], [CreatedBy],[Created],[Modified],[ModifiedBy],[ModifiedByID]) VALUES (4, N'AStartDate', N'下午营业开始时间', N'', N'2012-01-01 12:00:00',0,N'',getdate(),getdate(), N'',0)
INSERT [dbo].[ShopHoursConfig] ([ShopHoursConfigID], [ConfigName], [Title],[Content],[ShopHours],[Creater], [CreatedBy],[Created],[Modified],[ModifiedBy],[ModifiedByID]) VALUES (5, N'ASEndDate', N'下午营业结束购物时间', N'', N'2012-01-01 15:00:00',0,N'',getdate(),getdate(), N'',0)
INSERT [dbo].[ShopHoursConfig] ([ShopHoursConfigID], [ConfigName], [Title],[Content],[ShopHours],[Creater], [CreatedBy],[Created],[Modified],[ModifiedBy],[ModifiedByID]) VALUES (6, N'AEndDate', N'下午营业结束时间', N'', N'2012-01-01 15:30:00',0,N'',getdate(),getdate(), N'',0)
SET IDENTITY_INSERT [dbo].[ShopHoursConfig] OFF
